Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
ReportingPeriodID (FK)(PK) | The unique system assigned identifier for a particular ReportingPeriod. | ID_PRD_RP | Identity | integer | ReportingPeriod(CA_PRD_RP) |
ItemInventoryStateID (FK)(PK) | A unique retailer assigned identifier for ItemInventoryStates. | ID_ST_INV | Identity | integer | ItemInventory(LE_INV_ITM) |
ItemID (FK)(PK) | A unique system assigned identifier for the retailer's SKU. | ID_ITM | IdentityUUID | char(32) | ItemInventory(LE_INV_ITM) |
LocationID (FK)(PK) | A unique system assigned identifier for the Location. | ID_LCN | Identity | integer | ItemInventory(LE_INV_ITM) |
RevenueCostCenterID (FK)(PK) | A unique retailer assigned identifier for an accounting budget, that owns merchandise and is used to track the financial performance of the retail enterprise. | ID_CTR_RVN_CST | Identity | integer | ItemInventory(LE_INV_ITM) |
BeginningUnitCount | The number of units of the nominated Item present in the nominated InventoryLocation at the beginning of the nominated ReportingPeriod. | QU_BGN | Quantity | DECIMAL(9,3) | |
GrossSalesUnitCount | The number of units of the nominated Item sold from the nominated InventoryLocation since the beginning of the nominated ReportingPeriod, excluding any returns. | QU_SLS | Quantity | DECIMAL(9,3) | |
ReturnUnitCount | The number of units of the nominated Item returned to the nominated InventoryLocation since the beginning of the nominated ReportingPeriod. | QU_RTN | Quantity | DECIMAL(9,3) | |
ReceivedUnitCount | The number of units of the nominated Item received to the nominated InventoryLocation since the beginning of the nominated ReportingPeriod, excluding any returns. | QU_RCV | Quantity | DECIMAL(9,3) | |
ReturnToVendorUnitCount | The number of units of the nominated Item returned to Vendor from the nominated InventoryLocation since the beginning of the nominated ReportingPeriod. | QU_RTV | Quantity | DECIMAL(9,3) | |
TransferInUnitCount | The number of units of the nominated Item transferred into the nominated InventoryLocation since the beginning of the nominated ReportingPeriod. Note: Transfers include any Item's for which InventoryState was changed, but InventoryLocation did not change. | QU_TSF_IN | Quantity | DECIMAL(9,3) | |
TransferOutUnitCount | The number of units of the nominated Item transferred from the nominated InventoryLocation since the beginning of the nominated ReportingPeriod. Note: Transfers include any Item's for which InventoryState was changed, but InventoryLocation did not change. | QU_TSF_OT | Quantity | DECIMAL(9,3) | |
AdjustmentUnitCount | The number of units of the nominated Item for which InventoryAdjustments were made in the nominated InventoryLocation since the beginning of the nominated ReportingPeriod. | QU_ADJT | Quantity | DECIMAL(9,3) | |
EndingUnitCount | The number of units of the nominated Item present in the nominated InventoryLocation at the end of the nominated ReportingPeriod. | QU_END | Quantity | DECIMAL(9,3) | |